--SQLPLUS Comments
SQLPLUS hr/open
clear screen | cl scr
SHOW user
sql> connect system/sys   |   conn user_name/password
DISCONNECT | DISC

SET LINESIZE 180   | max : 2000
SET PAGESIZE 40    | 0

SELECT &a+&b FROM dual;
SELECT &&a+&b FROM dual;

SET VARIFY   ON | OFF
SET HEADING  ON | OFF
SET FEEDBACK ON | OFF
SET AUTOT    ON | OFF
SET TIMING   ON | OFF

TTITLE department_details
BTITLE eop

TTITLE OFF
BTITLT OFF

Diff between TTITLE and BTITLE

EDIT | ED   (avoid ; in the query | save | / to exxecute)


SPOOL "D:\log.txt"
SPOOL OFF

@"D:\IT\Technical\Source_Code\02_Session_Logs\2019_Logs\Script\script.sql"

COL first_name FOR a10
COL salary FOR 99,999.99$